SELECT distinct parentid,cid,cname,productuser,productaudit,productrelease,filepath from(SELECT a.parent_code parentid,a.areacode cid,a.areaname cname , null productuser,null productaudit,null productrelease,null filepath FROM AC_SYS_AREA_NAME a union all 
SELECT NVL(c.parentid,c.categoryarea ) as parentid ,c.cid cid,c.categoryname cname, null productuser,null productaudit,null productrelease,null filepath FROM ac_biz_category c union all 
SELECT p.categorycode as parentid ,p.productname,p.productname,p.productuser productuser,p.productaudit productaudit,p.productrelease productrelease,p.productfile filepath FROM ac_biz_product p where p.productpublish in ('waitsend','finishsend')) CONNECT BY PRIOR  parentid = cid 
START WITH cname like '%1%' or productuser like '%i%' or productaudit like '%i%' or productrelease like '%i%'